package scjhgl;

import java.util.List;

import com.jfinal.plugin.activerecord.Model;

public class Zzprscjh extends Model<Zzprscjh>  {

	public static final Zzprscjh dao =new Zzprscjh();
	
	/**
	 * 根据计划确认下达时间和生产班组编号，获取当前申请计划
	 * @param date 计划确认下达时间
	 * @param scbzbh 生产班组编号
	 * @return
	 */
	public List<Zzprscjh> getzzpscjhList(String date,int scbzbh){
		//return Zzprscjh.dao.find("select * from scjhgl_zzprscjh where fp_status = 0 and scbzbh= '"+scbzbh+"' and jhqrxdsj like '"+date+"_%'");
		//return Cprscjh.dao.find("select * from scjhgl_cprscjh where scbzbh= '"+scbzbh+"'");
		return Zzprscjh.dao.find("select * from scjhgl_zzprscjh where fp_status = 0 and scbzbh= '"+scbzbh+"' and rscjhbh = '"+date+"'");
	}
	
}
